|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Latest Answer : In Session properties SELECT treat source rows as UPDATE
In Target properties of session SELECT Insert, Update works like it updates if row is existing or Insert if the row is not existing. ... When importing data through fixed-width wizard, how will u distinguish between different columns if the file is of multiple lines terminated by a \n character. Read Answers (1) | Asked by : raj What is the main difference between mapping and mapplet designer in etl informatica and what transformations are used in the both? I am asked to create a detailed metadata about ,transformations used in perticular fact table mapping.How do i understand and create write up on what has happened to each port during each tranformations?By right click on port in target definition and choosing backward path , I could get complete path fot that port.Pls. adviseThanks, Read Answers (1) | Asked by : Adi Tags : Metadata Can anyone tell me , How to understand the use of transformations in informatica mapping for particular target port? Read Answers (8) | Asked by : Adi In Source 1 to 100 numbers? How can we load the even number in One target and odd number in another target?explain the mapping?How can we draw and wich transformations we r using?and explain logic? Read Answers (4) | Asked by : Reddy I am new to the informatica ..Can anyone explain stored procedure,sequence generator and lookup transformation with example... Read Answers (2) | Asked by : kalpana Im trying to fill a primary key field of a target using a trigger on the table to insert a sequence number for each insertion of a new row.After running the session im finding that the key column is populated ,but,not in an order. the key field starts with some 75 goes till 200,the again 551 comes and goes till 10500 ,suddenly the next key field is filled with 21 and goes till 72.... is there any reason why this is happening in this reason.FYI : i truncated the table data ,then dropped the seq. Read Answers (1) | Asked by : mayur Latest Answer : definatly ... I have a flat file which i am using as my source , i want to match the records in the flat files with that of my oracle table(using cust_id field). I was advised that i should be using a look up transformation and a filter transformation for this. I am not understanding why i should be using the look up transformation. can anyone please helpThanksNayana Read Answers (6) | Asked by : nayana
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
