Most voted questions under tag informatica

+2 votes

1 answer

What is the difference between source qualifier and normalizer in Informatica?

posted Mar 2, 2016 by Sachin

+2 votes

1 answer

Informatica: Provide a List of dynamic partitioning configurations that cause a session to run with one partition?

posted Feb 10, 2016 by Sunil

+2 votes

1 answer

What is a dynamic session partition in Informatica?

posted Feb 10, 2016 by Sachin

+2 votes

1 answer

Informatica: Pipeline partitions is designed to increase performance, however list some of it’s disadvantages?

posted Feb 10, 2016 by Amit Sharma

+2 votes

1 answer

Informatica: How to get EVEN & ODD numbers separately?

posted Jan 20, 2016 by Sunil

+2 votes

2 answers

Informatica: 1 lac or 100,000 of flat files in source how to load target at a time?

posted Jan 20, 2016 by Sachin

+2 votes

1 answer

What is Dynamic lookup Transformation in Informatica and when to use it?

posted Jan 20, 2016 by Amit Sharma

+2 votes

1 answer

What is the difference between informatica 7.1 and 8.6 versions?

posted Jan 18, 2016 by Amit Sharma

+2 votes

1 answer

what is the difference between stop and abort in Informatica?

posted Jan 18, 2016 by Sachin

+2 votes

2 answers

Informatica: If Source Qualifier transformation populates two target tables, How to ensure TGT2 is loaded after TGT1?

posted Jan 11, 2016 by Sunil

+2 votes

1 answer

Out of the two input pipelines of a joiner, which one will you set as the master pipeline?

posted Jan 11, 2016 by Amit Sharma

+2 votes

1 answer

Why we use enable high precision in session properties?

posted Oct 23, 2015 by Sunil

+2 votes

1 answer

I have 2 Sources, If 1st one Read sucessfully,Then only it has to move to read 2nd source? How can i do in informatica?

posted Oct 14, 2015 by Amit Sharma

+2 votes

1 answer

What is the difference between Informatica 7.1 and Abinitio?

posted Oct 9, 2015 by Sachin

+2 votes

0 answers

What are the transformations that are used in data cleaning ? and how data cleansing takes place ?

posted Sep 30, 2015 by Sunil

+2 votes

1 answer

How can we use sorter transformation in joins?

posted Sep 28, 2015 by Sachin

+2 votes

1 answer

How can you recover the session in sequential batches in Informatica?

posted Sep 28, 2015 by Amit Sharma

+2 votes

1 answer

What is a target load order?

posted Sep 21, 2015 by Sachin

+2 votes

1 answer

What is the difference between Connected and UnConnected Lookup Transformation.Give one or two examples?

posted Sep 21, 2015 by Amit Sharma

+2 votes

1 answer

Why cant we put a sequence generator or update strategy transformation before joiner transformation?

posted Sep 19, 2015 by Amit Sharma

+2 votes

1 answer

What are the differences between power center 8.1 and power center 8.5?

posted Aug 30, 2015 by Amit Sharma

+2 votes

1 answer

Explain the system testing and Integration Testing in the Informatica ?

posted Aug 30, 2015 by Sunil

+2 votes

0 answers

Informatica: PWX-02142 Field extends past end of record.

posted Aug 28, 2015 by anonymous

+2 votes

1 answer

What is star and snowflake schema in Informatica?

posted Aug 26, 2015 by Sunil

+2 votes

1 answer

Informatica: How do you optimized QlikView application? What Tools are used and where do you start?

posted Aug 21, 2015 by Amit Sharma

+2 votes

1 answer

How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations is it possible?

posted Aug 14, 2015 by Sachin

+2 votes

1 answer

How do you use sequence created in oracle at informatica? Explain with an simple example?

posted Aug 11, 2015 by Amit Sharma

+2 votes

1 answer

What is the difference between OLTP and ODS?

posted Aug 6, 2015 by Sunil

+2 votes

1 answer

How to run two workflows sequentially in informatica? What is the process?

posted Aug 6, 2015 by Sachin

+2 votes

1 answer

What is the function of 'F10' informatica ?

posted Aug 6, 2015 by Amit Sharma

+2 votes

3 answers

A table contains some null values. How to get (Not Applicable(NA)) in place of that null value in target?

posted Jul 31, 2015 by Sunil

+2 votes

2 answers

Informatica: In unconnected lookup what are other transformations that can be used in place of expression transformation

posted Jul 24, 2015 by Sunil

+2 votes

1 answer

What are two types of processes that informatica runs the session?

posted Jul 24, 2015 by Sachin

+2 votes

1 answer

What are the differences between joiner transformation and source qualifier transformation?

posted Jul 22, 2015 by Sachin

+2 votes

1 answer

How the informatica server sorts the string values in Rank transformation?

posted Jul 13, 2015 by Sunil

+2 votes

1 answer

What are partitions in informatica and which one is used for better performance?

posted Jul 13, 2015 by Sachin

+2 votes

1 answer

How you know when to use a static cache and dynamic cache in lookup transformation?

posted Jul 13, 2015 by Amit Sharma

+2 votes

1 answer

Informatica: Difference between star and snowflake schema?

posted Jul 2, 2015 by Amit Sharma

+2 votes

1 answer

How to load only the first and last record of a flat file into the target?

posted Jun 25, 2015 by Sachin

+2 votes

1 answer

Informatica: Confirmed Dimension, Junk Dimension, Degenerated Dimension, Slowly changing Dimensions?

posted Jun 23, 2015 by Sachin

+2 votes

1 answer

What is update strategy transformation ?

posted Jun 8, 2015 by Sunil

+2 votes

0 answers

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

posted May 27, 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

+2 votes

1 answer

How to join 2 tables, without using any condition?

posted May 6, 2015 by Amit Sharma

+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

+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

+2 votes

1 answer

What does mean of lookup transformation in Informatica?

posted Mar 22, 2015 by Amit Kumar Pandey