Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

how to insert header after each group.

IBM,

1 1483

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

940

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

CTS,

703

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

CTS,

739

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

CTS,

712

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

CTS,

791

What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).

CTS,

1 720

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

1779

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

792

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

979

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

HP,

900

In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

HP,

1 1282

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

IBM,

812

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

Accenture,

1 1411

How do you join more than 3 flat files in informatica?

ITC Infotech,

1 1433


Post New Informatica Questions






Un-Answered Questions { Informatica }

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

1802


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

7025


What are the different components of powercenter?

156


How can you define user defied event?

153


What the difference is between a database, a data warehouse and a data mart?

146






How to generate sequence numbers without using the sequence generator transformation?

180


What is data transformation manager process?

151


Explain the mapping variable usage example in informatica

165


How do we call shell scripts from informatica?

148


update strategy transformation in informatica

182


How do you load only null records into target?

139


if we have a delimiters at unwanted places in a flat file how can we over come those.

1108


Using Connected or unconnected lookup for performance wise which one is preferable?.

510


Explain sessions?

154


Explain lookup transformation source types in informatica

179