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 / sreenu
yes
but if it is a relational table beter to use SQL overried
for performence
for flat files u have to use filter t/r
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Different qualification between a related rotate toward the sky and isolates look upward?
What is data caches/ index caches?
What is meant by pre and post session shell command?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What are the different clients of powercenter?
What could be the possible resons of locks by user?
what are the Methods For Creating Reusable Transformations?
What are pre and post-session shell commands?
Explain the informatica workflow?
How do you use reject loader.
What is the Process to creating lookup transformation in informatica
What are the new features of Power Center 5.0?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Explain lookup transformation is active in informatica
What is status code in informatica?