What are the challenges you have faced in your project?
- 1 Answers
- 17358 Views
- Cognizant, Infosys, I also Faced
- E-Mail Answers
Answer / jeevan kumar medapati
in real time we are frequntly facing some problems such as
environ mental issues, missing links,column mismatch etc.
| Is This Answer Correct ? | 1 Yes | 10 No |
How do you load only null records into target?
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks
What is the use of target designer?
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
What is rank transformation?
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.
what is upstream and downstream transformation?
what is degenerated dimension?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Hi All can anyone tell me where i will get Informatica training in Mumbai?
What is xml source qualifier transformation in informatica?
Teradata 
