Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?

Mind Tree, Polaris,

4 5390

can u give example for factless fact table

TCS,

2 4317

how we load the data from source to staging area

TCS,

4 5886

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

IBM,

4 6392

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

IBM,

6 4650

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

IBM,

969

Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks

IBM,

3 3574

Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

IBM,

2 7529

Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.

IBM,

3 7362

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.

IBM,

3 4416

Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks

IBM,

2 4636

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1133

what is target load plan

Cap Gemini,

2 4324

what is constraint based load order

Cap Gemini,

2 4914

what is fact and what types of fact tables is there

Cap Gemini,

4 7969


Post New Informatica Questions






Un-Answered Questions { Informatica }

What is a shortcut and copy in Informatica and how two are different with each other?

180


What are the features of complex mapping?

147


Could you explain what is enterprise data warehouse?

159


have u done any performance tuning? how u ll do?

1367


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

148






What are the designer tools for creating transformations?

191


What are pre and post-session shell commands?

148


Explain what is informatica metadata and where is it stored?

160


What is option by which we can run all the sessions in a batch simultaneously?

179


Different sorts of metadata that stores in the storage facility?

160


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

6621


Is there any target staging area in informatica not staging area

1635


What do you mean by worklet?

161


What are the prerequisite tasks to achieve the session partition?

157


How can we store previous session logs?

132