Most answered questions under tag informatica

+1 vote

1 answer

How will you get 1 and 3rd and 5th records in table? What is the query in oracle?

posted Sep 4, 2015 by Amit Sharma

+1 vote

1 answer

Checkout and checking in informatica 8.6?

posted Sep 2, 2015 by Sunil

+1 vote

1 answer

Describe two levels in which update strategy transformation sets?

posted Sep 2, 2015 by Sachin

+1 vote

1 answer

What is the default join that source qualifier provides?

posted Sep 2, 2015 by Amit Sharma

+1 vote

1 answer

In a table, 4 person having same salary. How to get Third person record only?

posted Sep 1, 2015 by Amit Sharma

+1 vote

1 answer

When we go for unconnected lookup transformation? and why?

posted Sep 1, 2015 by Sachin

0 votes

1 answer

What is the monster dimension ?

posted Sep 1, 2015 by Sunil

+3 votes

1 answer

Whether Sequence generator T/r uses Caches? then what type of Cache it is?

posted Aug 30, 2015 by Shweta Singh

+3 votes

1 answer

If we are using aggregator we enabled sorted input but the records are not sorted what happen?

posted Aug 30, 2015 by Shweta Singh

+1 vote

1 answer

Why we need to use unconnected transformation?

posted Aug 30, 2015 by Sachin

+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

1 answer

What is star and snowflake schema in Informatica?

posted Aug 26, 2015 by Sunil

+1 vote

1 answer

What are surrogate keys usage in Oracle and Informatica?

posted Aug 26, 2015 by Sachin

+1 vote

1 answer

Can we generate reports in informatica, if yes then how if no then why not?

posted Aug 26, 2015 by Amit Sharma

+1 vote

1 answer

What is Target Update Override? What is the Use ?

posted Aug 21, 2015 by Sunil

+1 vote

1 answer

If the session fails after 100 records again we have to starts the session or we go for recovery session?

posted Aug 21, 2015 by Sachin

+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

0 votes

1 answer

What are the mappings that we use for slowly changing dimension table?

posted Aug 19, 2015 by Amit Sharma

+1 vote

1 answer

What is fact less fact schema?

posted Aug 18, 2015 by Sunil

+1 vote

1 answer

Informatica: How can we eliminate duplicate rows from flatfile, please explain?

posted Aug 18, 2015 by Sachin

+1 vote

1 answer

Informatica: Flat file heaving 100,000 records and I want to push 52,000 records to the target?

posted Aug 18, 2015 by Amit Sharma

+1 vote

1 answer

What is the name of that port in dynamic cache which is used for insert?

posted Aug 14, 2015 by Sunil

+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

0 votes

1 answer

If we have 10 records in a file, can we get first record from it by using Aggregator with out using Group by Port in it?

posted Aug 14, 2015 by Amit Sharma

+1 vote

1 answer

How to lookup is acting as both active and passive ? how is it possible?

posted Aug 11, 2015 by Sunil

+1 vote

1 answer

What are sample mappings for scd1,scd2 and scd3?

posted Aug 11, 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

+1 vote

1 answer

How can we eliminate duplicate values from lookup without overriding sql?

posted Aug 3, 2015 by Sunil

+1 vote

1 answer

What is the filename which you need to configure in UNIX while installing infromatica?

posted Aug 3, 2015 by Sachin

+1 vote

1 answer

What is Kimball and Inmon methodologies?

posted Aug 3, 2015 by Amit Sharma

0 votes

1 answer

What is the difference between informatica versions 8.1.1 and 8.6.1?

posted Jul 31, 2015 by Sachin

+1 vote

1 answer

How to run two workflow (not a sessions) sequentially in Informatica, what is the process?

posted Jul 31, 2015 by Amit Sharma

0 votes

1 answer

What is file list concept in informatica?

posted Jul 28, 2015 by Sunil

0 votes

1 answer

What happens if you increase commit intervals and also decrease commit Explain grouped cross tab?

posted Jul 28, 2015 by Sachin

0 votes

1 answer

Informatica: How do u get the first record from 50,000 records?

posted Jul 28, 2015 by Amit Sharma

+2 votes

1 answer

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

posted Jul 24, 2015 by Sachin

+1 vote

1 answer

Informatica: How do u get the first record from n records say 50,000?

posted Jul 24, 2015 by Amit Sharma

+1 vote

1 answer

What is the version controlling in informatica?

posted Jul 22, 2015 by Sunil

+2 votes

1 answer

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

posted Jul 22, 2015 by Sachin

+1 vote

1 answer

Informatica: If session fails after loading 10000 records in the target, how can we load 10001 the record when run next?

posted Jul 22, 2015 by Amit Sharma

+1 vote

1 answer

In informatica, if i have some number of records, if i want 1st and 10th records, What will be the method to use?

posted Jul 20, 2015 by Sunil

0 votes

1 answer

What is the logic will you implement to load data into a fact table from dimension tables?

posted Jul 20, 2015 by Sachin

+1 vote

1 answer

Why is meant by direct and indirect loading options in sessions?

posted Jul 20, 2015 by Amit Sharma

+1 vote

1 answer

What are the session parameters?

posted Jul 16, 2015 by Sunil

0 votes

1 answer

How to run the batch using pmcmd command?

posted Jul 16, 2015 by Sachin

+1 vote

1 answer

How do you perform incremental load?

posted Jul 14, 2015 by Sunil