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?
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 is rank transformation?
Where is metadata stored?
How to create Target definition for flat files?
What is the Process to creating lookup transformation in informatica
In how many ways we can create ports?
Is stop and abort are same in informatica?
How to extract sap data using informatica?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
have u done any performance tuning? how u ll do?
Write the different tools in the workflow manager?
Write the advantages of partitioning a session?
What is InformaticaPowerCenter?
what is song in infrmatica...?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How many input parameters can exist in an unconnected lookup?