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

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

Question Posted / sunil.knl

2 Answers
9005 Views
HCL, I also Faced
E-Mail Answers

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

in performance wise union is past,union all is past

2 Answers

What are the differences between a connected lookup and unconnected lookup?

0 Answers

What is update strategy transform?

0 Answers

Why we need XMLs?

3 Answers IBM,

Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers Wipro,

Can anyone tell me the new features in Informatica 9 Version?

2 Answers Syntel,

What is union transformation?

0 Answers

Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers Informatica,

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

0 Answers

What is use of batch file in informatica? How many types of batch file in informatica?

2 Answers EXL,

How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

1 Answers Wipro,

What are the join types in joiner transformation?

1 Answers Informatica,

For more Informatica Interview Questions Click Here