hi all, i have 1 flat file having 10 rows. like:-
id name amt
100 a 100
200 b 200
100 n 300
400 p 3000
100 a 100
600 x 6000
Now i want to load half of this data into one flat file and
remaining in other flat file.like :-
flat file 1
id name amt
100 a 100
200 b 200
100 n 300
----------------------
----------------------
flat file 2
id name amt
400 p 3000
100 a 100
600 x 6000
Plz reply me ASAP.
Answer Posted / indra
NOT GOT APPROPRIATE RESULT BY GOING THROUGH THE SOLUTION
GIVEN BY Shashank....
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is domain in terms of informatica?
what is the -ve test case in your project.
What is the difference between informatics 7x and 8x and what is latest version?
What are the settings that you use to configure the joiner transformation?
What is a code page?
Separate from an archive server and a powerhouse?
Do you find any difficulty while working with flat files as source and target?
Design time, run time. If you don't create parameter what will happen
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
where to store informatica rejected data?
What can we do to improve the performance of informatica aggregator transformation?
Explain the different lookup methods used in informatica?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?