Follow Our FB Page << >> 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 dis way ...? how to achieve dis?

Mind Tree, Polaris,

4 5390

can u give example for factless fact table


2 4317

how we load the data from source to staging area


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


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


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



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


3 3574

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


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.


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.


3 4416

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


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.


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?


What are the features of complex mapping?


Could you explain what is enterprise data warehouse?


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


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?


What are the designer tools for creating transformations?


What are pre and post-session shell commands?


Explain what is informatica metadata and where is it stored?


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


Different sorts of metadata that stores in the storage facility?


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?


Is there any target staging area in informatica not staging area


What do you mean by worklet?


What are the prerequisite tasks to achieve the session partition?


How can we store previous session logs?