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
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Define mapping and session?
What is confirmed fact in dataware housing?
What are the informatica performance improvement tips
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
whats the logic to load the lower level of granularity of data to fact table.
What are the data movement modes in informatica?
Explain transaction control transformation in informatica
Differences between connected and unconnected lookup?
What are the new features of informatica 9.x developer?
How to open an older version of an object in the workspace?
What is the surrogate key?
What are the new features of Power Center 5.0?
Why do we need informatica?
How to improve the performance of a session using sorter transformation?