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 10389Hi, 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 8354Hi, 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
1917Hi, 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 5958Hi, 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 10011Hi, 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 7112Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks
2 6610im 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 5126Post New IBM Interview Questions
Where web.config file is used?
How can you log an error to the server event log from a stored procedure?
What do you understand by datacontext class? How is it related to linq?
What are the types of authentication?
What do you mean by a windows process in regards to memory allocation?
How do I add gridlines to a table in word?
Which is better curl or wget?
Define different types of hooks in wordpress.
This is related to Medical Transcription field. As i am above to get the call from the company, I just want to prepare for the interview for the post of Auditor and I have just never faced the telephonic interview and very rare attempted the interview in companies as I have worked for very few companied.
What is default constraint?
What is the purpose of a watchdog timer?
What are sealed classes in flex? : adobe flex action script
Is it possible to combine multiple .ts files into a single .js file? If yes, then how?
What is the best way to create the stacked chart in d3 js?
Tell me how you are ready to comply with the employment rules and regulations if your CV is considered for employment?