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 15793Hi, 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 20303follwing 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 9843can 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
4779in 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 7340if 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 29709if 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 6356i 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 15608Suppose 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 9390Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
1 6252Post New IBM Informatica Interview Questions
Is condition checking possible in jcl? If yes, how?
What is a one-to-one association in hibernate?
What are the advantages of vbscript?
Explain the role of NLP in human-AI interaction.
What is the difference between jsp and php?
Is php better than c#?
What is the shortcut to insert equation in word?
What are clob and blob data types in jdbc?
What are the three types of file system?
Explain the Algorithm of Support vector machines in Machine Learning?
Describe a opening balance?
Define feature vector?
What is a newline escape sequence?
What is application tier?
What do you do when windows fails to start?