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
Explain the different kinds of facts.
What are the differences between source qualifier and joiner transformation?
Explain about cumulative Sum or moving sum?
without table how to come first record only in oracle?
How does a rank transform differ from aggregator transform functions max and min?
what is song in infrmatica...?
What is the use of transformation?
What are the different components of powercenter?
Can informatica load heterogeneous targets from heterogeneous sources?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Have you worked with/created Parameter file
what is unit testing?tell me proceedure
State the limitations where we cannot use joiner in the mapping pipeline?
Clarify the utilization of aggregator cache record?
What is Index Caches size?