Interested to Buy Any Domain ? << Click Here >> for more details...
why we r using presql&postsql in source qualifier?
- 1 Answers
- 6029 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / amedela chandra sekhar
Presql :sql statement executed before the session retrive
the data from source.
Postsql:sql statement executed atfer the session retrive the
data from source.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
Define joiner transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?
Explain scd type 3 through mapping.
What all join we can perform in LOOKUP transformation?
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
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What if the source is a flat-file?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What does cheating measurement mean?
How can one identify whether mapping is correct or not without connecting session?
whats the logic to load the lower level of granularity of data to fact table.
How do you use reject loader.
What is the difference between a connected look up and unconnected lookup?
differences between service based and product based?
what are factless facts? And in which scenario will you use such kinds of fact tables.
