Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?
DELL,
2 8176Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
2109In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
8 14626Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.
4 10681I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible
IBM,
3 6287I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
3 9978what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
3 10413My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
2 6547Post New Informatica Questions
what is diff b/t sorter t/r and agg have the option sorter property...
How to generate sequence numbers?
What are the components of the workflow manager?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is the sql query overwrite in source qualifier in informatica
what is the -ve test case in your project.
what is the difference between informatica6.1 and infomatica7.1
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Mention few advantages of router transformation over filter transformation.
How to load the data from a flat file into the target where the source flat file name changes daily?
Reusable transformation and shortcut differences
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is the difference between source qualifier transformations source filter to filter transformation?
Clarify the utilization of aggregator cache record?
