in realtime which situations u can use unconnected lookup
transformation
Answers were Sorted based on User's Feedback
Answer / amedela chandra sekhar
When we want to get single return port and also we can call
this any where in the mapping.
| Is This Answer Correct ? | 11 Yes | 1 No |
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
without using rank transformation how can we rank items by using some other transformations
Please let me know how to make encryption and decryption with example?
Explain load alternative records / rows into multiple targets - informatica
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
Why use the lookup transformation ?
If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
How informatica process data means how informatica works?
what is degenerated dimension table with scenario