Interested to Buy Any Domain ? << Click Here >> for more details...
we have table like cust_id,cust_name,cust_loc like this
1.we need to get perticular location,to do this we can use
filter transformatin,that logic is same for relation table
and flat file tabl?
- 2 Answers
- 6190 Views
- I also Faced
- E-Mail Answers
Answer Posted / rahul
You can write the SQL statement for that particular
location in the source qualifier if it is a relational
table.
Use Filter if it is a flat file.
| 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 are the different types of transformation available in informatica.
Enlist few areas or real-time situations where informatica is required.
What are the conditions needed to improve the performance of informatica aggregator transformation?
Briefly describe lookup transformation?
What is meant by active and passive transformation?
What is complex mapping?
What are session parameters ? How do you set them?
What is workflow? What are the components of workflow manager?
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?
How to update or delete the rows in a target, which do not have key fields?
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?
What is an aggregator transformation?
What is expression transformation?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
