Recent posts under tag informatica

0 votes

1 answer

Informatica: How to pass unique values to one table and duplicate values to another one in a single mapping?

posted Sep 16, 2015 by Sunil

+1 vote

1 answer

Informatica: Which gives more performance when compare to fixed width and delimited file ? and why?

posted Sep 16, 2015 by Amit Sharma

+1 vote

1 answer

Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

posted Sep 15, 2015 by Sunil

+1 vote

1 answer

What is the Rank index in Rank transformation?

posted Sep 15, 2015 by Sachin

+1 vote

1 answer

What are the options in the target session of update strategy transformation?

posted Sep 15, 2015 by Amit Sharma

+1 vote

1 answer

What is Data driven?

posted Sep 14, 2015 by Sunil

+1 vote

1 answer

What are the options in the target session of update strategy transformation?

posted Sep 14, 2015 by Sachin

0 votes

1 answer

How the server recognizes , if the session fails after loading the 100 records in to the target?

posted Sep 14, 2015 by Amit Sharma

+1 vote

0 answers

multiple dynamic single row columns to multiple rows

posted Sep 11, 2015 by Dhanashree Patil-Prasun

+1 vote

1 answer

What are the different types of modeling in Informatica?

posted Sep 9, 2015 by Sachin

+1 vote

1 answer

Informatica: Without source how to insert record to target?

posted Sep 9, 2015 by Amit Sharma

0 votes

1 answer

What is rank and dense rank in informatica with any examples and give sql query for this both ranks?

posted Sep 8, 2015 by Sunil

0 votes

1 answer

What are the joiner caches?

posted Sep 8, 2015 by Sachin

0 votes

1 answer

In operator is used in which transformation in informatica 8.6.0?

posted Sep 4, 2015 by Sunil

+1 vote

1 answer

Difference between persistence and dynamic caches? On which conditions we are using these caches?

posted Sep 4, 2015 by Sachin

+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

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

+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