Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 10 Answers
- 16228 Views
- I also Faced
- E-Mail Answers
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 is native users?
What do you mean by filter transformation?
Clarify the aggregator change?
write a query to retrieve the latest records from the table sorted by version(scd)
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Write the program through which the records can be updated?
Different sorts of metadata that stores in the storage facility?
What is the use of source qualifier?
What is the reusable transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Explain the features of connected and unconnected lookup.
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are the main issues while working with flat files as source and as targets ?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What happens when a session fails and you click on recover?
