Recent posts under tag informatica

+2 votes

0 answers

Is it possible to create set in a particular range of sales

posted May 27, 2015 by Amit Sharma

+1 vote

1 answer

What is Function MD5?

posted May 25, 2015 by Sunil

+1 vote

1 answer

Filter Transformation

posted May 25, 2015 by Sachin

+1 vote

1 answer

How many ways can we implement SCD2?

posted May 25, 2015 by Amit Sharma

+1 vote

1 answer

Loading 5 flat files of having same structure to a single target

posted May 20, 2015 by Sunil

+1 vote

1 answer

How will you combine 3 different sources with a single source?

posted May 20, 2015 by Sachin

+1 vote

1 answer

Ln which situations do you go for scds ?

posted May 20, 2015 by Amit Sharma

+1 vote

1 answer

What is difference between portioning of relational target and partitioning of file targets?

posted May 12, 2015 by Sunil

+1 vote

1 answer

How can you recognize whether or not the newly added rows in the source are gets insert in the target ?

posted May 12, 2015 by Sachin

+1 vote

1 answer

How to display null values on a target & non-null values on a target?

posted May 12, 2015 by Amit Sharma

0 votes

1 answer

How can we delete a record or truncate in target table using SQL T/R?

posted May 11, 2015 by Sunil

0 votes

1 answer

Fillter transformation condition

posted May 11, 2015 by Sachin

0 votes

1 answer

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

posted May 11, 2015 by Amit Sharma

+2 votes

1 answer

What are the limitations for bulk loading in informatica for all kind of databases and transformations?

posted May 7, 2015 by Amit Sharma

+1 vote

1 answer

What is complex mapping in informatica

posted May 6, 2015 by Sachin

+2 votes

1 answer

How to join 2 tables, without using any condition?

posted May 6, 2015 by Amit Sharma

+1 vote

1 answer

Loading Target Tables

posted May 4, 2015 by Sunil

0 votes

1 answer

Override SQL Query and the OUTPUT PORTS

posted May 4, 2015 by Sachin

0 votes

1 answer

Source Filter, Select Distinct and Number Of Sorted Ports

posted May 4, 2015 by Amit Sharma

0 votes

1 answer

How many types of dimensions are available in Informatica?

posted Apr 22, 2015 by Sunil

+2 votes

1 answer

What is operational Data Store?

posted Apr 22, 2015 by Sachin

+2 votes

1 answer

What is Data Mining?

posted Apr 22, 2015 by Amit Sharma

+1 vote

1 answer

What is Data mart?

posted Apr 16, 2015 by Amit Sharma

+1 vote

1 answer

What happens to a mapping if we alter the datatypes between Source and its corresponding Source Qualifier?

posted Apr 14, 2015 by Sunil

+1 vote

1 answer

What is a Source Qualifier? What are the tasks we can perform using a SQ and why it is an ACTIVE transformation?

posted Apr 14, 2015 by Sachin

+1 vote

1 answer

Why is Sorter an Active Transformation?

posted Apr 14, 2015 by Amit Sharma

+1 vote

1 answer

What are the basic needs to join two sources in a source qualifier?

posted Apr 9, 2015 by Sachin

+1 vote

1 answer

Where to store informatica rejected data? How to extract the informatica rejected data ?

posted Apr 9, 2015 by Amit Sharma

+1 vote

1 answer

What are the prerequisite tasks to achieve the session partition?

posted Apr 8, 2015 by Sachin

+2 votes

1 answer

What is the scenario which compels informatica server to reject files?

posted Apr 8, 2015 by Amit Sharma

+2 votes

1 answer

What is junk dimension and mystery dimension in context of Informatica?

posted Apr 7, 2015 by Sachin

+2 votes

1 answer

Informatica: Is fact a denormalized or a normalized table?

posted Apr 7, 2015 by Amit Sharma

+1 vote

1 answer

What is target load order under Informatica?

posted Apr 5, 2015 by Amit Kumar Pandey

+1 vote

1 answer

Where can we find the throughput option in informatica?

posted Apr 5, 2015 by Amit Kumar Pandey

+1 vote

1 answer

What is a mapplet in Informatica?

posted Apr 5, 2015 by Amit Kumar Pandey

+3 votes

1 answer

How can repository reports be accessed without SQL or other transformations?

posted Apr 1, 2015 by Sachin

+3 votes

1 answer

What is stand alone sessions. In case of failure how can they be recovered?

posted Apr 1, 2015 by Amit Sharma

+1 vote

1 answer

How batches are used to combine executions.

posted Mar 30, 2015 by Sunil

+1 vote

1 answer

Data Transformation Manager creates which different threads?

posted Mar 30, 2015 by Sachin

+1 vote

1 answer

What are fact table?

posted Mar 30, 2015 by Amit Sharma

+1 vote

1 answer

What is Stored Procedure Transformation?

posted Mar 27, 2015 by Sunil

+1 vote

1 answer

What are lookup caches?

posted Mar 27, 2015 by Sachin

+1 vote

1 answer

Which files are created during the session runs by Informatica server?

posted Mar 27, 2015 by Amit Sharma

+1 vote

1 answer

how batches are used to combine executions.

posted Mar 24, 2015 by Sunil

+1 vote

1 answer

Data Transformation Manager creates which different threads?

posted Mar 24, 2015 by Sachin

+1 vote

1 answer

What is load order?

posted Mar 24, 2015 by Amit Sharma

+1 vote

1 answer

Where the throughput found in the Informatica available?

posted Mar 23, 2015 by Sachin

+1 vote

1 answer

What is On-Line Analytical Processing( OLAP)?

posted Mar 23, 2015 by Amit Sharma

+2 votes

1 answer

What does mean of lookup transformation in Informatica?

posted Mar 22, 2015 by Amit Kumar Pandey

+2 votes

1 answer

What do you mean by Enterprise Data Warehousing?

posted Mar 22, 2015 by Amit Kumar Pandey