1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

sorce is a flatfile only 1st and last row should insert to
target how will u do?

Question Posted / sunil.knl

Answers were Sorted based on User's Feedback



sorce is a flatfile only 1st and last row should insert to target how will u do?..

Answer / balu

sourcce --> source qualifier--> sequence generator--
>expression trns-->target

generate sequence for the source data after that in
expression transformation use min and max function on
sequece then connect to target.

Is This Answer Correct ?    6 Yes 5 No

sorce is a flatfile only 1st and last row should insert to target how will u do?..

Answer / mike

well If your source is a flatfile and you are loading it in
to relational database or a flat file again, then you can
use union transformation to insert the first and last row

correct me if i was wrong

Is This Answer Correct ?    1 Yes 5 No

Post New Answer

More Informatica Interview Questions

how to get the data from the client machine and how to get server location data to client loction can any body explain to me

1 Answers   TCS,

where is the reject loader .

1 Answers  

If I have a index defined on target table and if set it to bulk load will it work ?

4 Answers   IBM,

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  




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

1 Answers   ITC Infotech,

In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

2 Answers   Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,

What is informatica etl tool?

0 Answers  

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

4 Answers   TCS,

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

5 Answers   Cap Gemini,

I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 Answers  

For more Informatica Interview Questions Click Here
Categories