AT the max how many transformations and mapplets can we use
in a mapping ?
Answer / j.david sukeerthi kumar
No restrictions on the numbers, we can use as many se we can.
Is This Answer Correct ? | 23 Yes | 0 No |
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
What is aggregate cache in aggregator transformation?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
Explain lookup transformation is active in informatica
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
What is informatica etl tool?
In informatica workflow manager, how many repositories can be created?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
whats the option in informatica 7 version is outdated in informatica 8 version onwards.