How to load the data from a flat file into the target where the source flat file name changes daily?
No Answer is Posted For this Question
Be the First to Post Answer
Differnce between filter and router?
any body can say about all versions of informatica ?how many versions ?
On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
What are the data movement modes in informatica?
What is the function of look up transformation?
Why do you use Mapping Parameter and mapping variable?
What is Target Update Override? What is the Use ?
Explain the aggregator transformation?
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
wat s mapping parameter and mapping variable? how do you set that in a mapping?
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this