Explain informatica architecture - version 8 / 9
No Answer is Posted For this Question
Be the First to Post Answer
what is fact and what types of fact tables is there
How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).
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
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
why dimenstion tables are denormalized in nature ?
Can a joiner be used in a mapplet.
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
enterprise datawarehouse your project phase by phase explain?
what is the diff b/w cached and unchaed look ups
What is repository manager?