Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of caches in lookup?
- 0 Answers
- 1061 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?
what is a transforamation?
I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
How can a transformation be made reusable?
Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
what are objects in data warehouse?
What is the term PIPELINE in informatica ?
how to load duplicate row in a target
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
Teradata 
