i have to extract data from a flat file.the flat file has 10
records.i have to extract the 1st and 5th record every
time.how is it done.

Answer Posted / sunny

Simple.Take arithematic calculation, record divisible by five if result is zero then pass it where u want,for first record pass it directly.It's c logic man.i gave one idea that much only.

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is repository manager?

533


How many dimensions are there in informatica?

623


Explain scd type 3 through mapping.

576


Define mapping and session?

581


Explain the scenario which compels informatica server to reject files?

654






Explain what are the different versions of informatica?

653


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1850


What is the sql query overwrite in source qualifier in informatica

613


EXL informatica Questions

929


What are the data movement modes in informatica?

696


Explain pushdown optimization $pushdownconfig parameter - informatica

697


How we can create indexes after completing the loan process?

725


How many types of sessions are there in informatica.please explain them?

674


Can you use flat files in Mapplets.

2214


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1681