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
- 6273 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
Explain direct and indirect flat file loading (source file type) - informatica
How can we store previous session logs?
Explain the different dimensions.
Differentiate between a repository server and a powerhouse?
Explain the aggregator transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is intricate mapping?
What is powercenter on grid?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Performance tuning( what you did in performance tuning)
How to generate sequence numbers?
What is a surrogate key?
How to improve the performance of a session using sorter transformation?
