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 10414Hi, 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
7 8394Hi, 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
1 1926Hi, 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 5978Hi, 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 10036Hi, 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 7128Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks
2 6630im trnsfering 10 data records from outbound though idocs but 8 records are transferred , what about remaing records but it did not show any error?
1 5139Post New IBM Interview Questions
What do you know about our organization
what is document design in boxi,have u participate in that
Hi any one send me the configuration steps for make to order and make to stock in sap .send to my mail id c.sujatha2008@gmail.com
Why are you attracted to science and science fiction?
what is associativity explain what is the precidence for * and & , * and ++ how the folloing declaration work 1) *&p; 2) *p++;
What’s powershell, and how do you feel about it?
According to RBI rule how much money can be transferred through online banking at one time...?
Where we have to use perl scripting in Testing approach and its importance
Why Honeywell?
TO CALCULATE THE RESISTANCE OF GRR OF HT MOTOR 400KW WHEREAS STATOR VOLTAGE 6.6KV AND ROTOR VOLTAGE 705V AND ROTOR CURRENT IS 346A.
How to convert a string to a number using javascript?
pls send the technical question paper
Is primary key always clustered index?
How to convert GSS duct volume in KG for all guages
How can AI be used to predict patient outcomes?