What are the differences between oltp and olap?
No Answer is Posted For this Question
Be the First to Post Answer
What are the types of lookup transformation?
How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
Can we use parameters of parameter file in presession command
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
how can we load 365 flat file to a single fact table (target) as a history load in single mapping?
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,
how to insert header after each group.
What is informatica worklet?
I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How to load the data from a flat file into the target where the source flat file name changes daily?
In a sequential batch can u run the session if previous session fails?