Scheduling properties,whats the default (sequential)
No Answer is Posted For this Question
Be the First to Post Answer
I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?
What do think which one is the better joiner or look up?
one source to target loading insert new rows and update existing rows?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
Define joiner transformation?
Explain what are the different types of transformation available in informatica.
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 is dimension table?
What are the measure objects?
write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24
what is surrogate id ?
hw cn v elimate dublicate values from lookup without overriding sql?