I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
No Answer is Posted For this Question
Be the First to Post Answer
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...
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?
2 Answers Patni, Tech Mahindra,
i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is the difference between SOURCE and TARGET BASED COMMITS?
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
Explain pushdown optimization $pushdownconfig parameter - informatica
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?