I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance
6 12679Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc
10 14952follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
5 7339can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
4079in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
2 5471if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!
8 24831if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??
1 4658i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
10 10686Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
4 6942Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
1 4817Post New IBM Informatica Interview Questions
What is the login shell?
sample sbi questions paper
What parameter of the job statement is used to limit the cpu time consumed by the job?
Difference between uniqe index and uniqe constraint?
How are white-spaces handled by xml?
How do you perform annual closing in sap? : fi- general ledger
What is mrp controller means?
What are web resources in jsf (javaserver faces)?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What is the difference between limit of quantification and limit of quantitation?
Explain the use of sections module in drupal.
What are the disadvantages of using ms word?
Explain data mover.
How does error handling occur with jstl?
How we will dabit profit & Loss a/c in tally because profit & Loss a/c is tally generated a/c. we have to make provision for tax.