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.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

What is the difference between informatica 8.x and 9.x

1 Answers   Wipro,


i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

3 Answers   Satyam,


Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers  


what is metadata?

8 Answers   Satyam,


What are the advantages of using informatica as an etl tool over teradata?

0 Answers  






we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,


without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,


What did you do in source pre load stored procedure

1 Answers  


What is a surrogate key?

0 Answers  


What are Target Options on the Servers?

1 Answers  


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

2 Answers  


Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.

7 Answers   Cognizant, Wipro,


Categories