Interested to Buy Any Domain ? << Click Here >> for more details...
I have 4 columns in a table say, name ,address, salary and
city. So based on distinct city names, i need to combine
the other data and send it to a flat file. Distinct city
names can be 4 or 5 or 6. So it has to dynamically generate
flat files(4 or 5 or 6) corresponding to the city names.
- 2 Answers
- 6122 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ankit kansal
steps:-
1)Bring source and target into a mapping
*remember to check the target file name option in target analyzer window for that target.
2)sort your data on the basis of city.
3)In expression transformation
o_flag-----o---IIF(prev_city=city,0,1)
prev_city--v---city
o_file_name--o--city
*remember the order must be same
4)Take Transaction Control
IIF(o_flag=1,TC_COMMIT_BEFORE,TC_CONTINUE_TRANSACTION)
i hope it helped you.
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / hari
transaction control transformation will do this logic
dymanically.
using shell programming we can split those files using post
command task
| Is This Answer Correct ? | 1 Yes | 0 No |
What is meant by incremental aggregation?
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
What is limitations of truncate and load option
i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?
Do you have to change the reject file b4 using reject loader utility.
What is status code in informatica?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
how do u move the code from development to production?
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
Hi All can anyone tell me where i will get Informatica training in Mumbai?
Types of error logs in Informatica?
What is a shortcut and copy in Informatica and how two are different with each other?
Teradata 
