Interested to Buy Any Domain ? << Click Here >> for more details...
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 Answers
- 15414 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manu
Hi IBM,
I have a solution for this.
1) From source qualifier get the records to the Expression.
2) Use one Sequence generator in which set the max value as
3 , enable cycle option. Connect it to the expression.
3) then use router & create 2 groups, 1st group condition
as Next value = 1 another as next value = 2 and default.
4) These should be connected to the 3 target tables.
The requirement will be achieved.
| Is This Answer Correct ? | 29 Yes | 3 No |
Answer / srinivas
I had another simple solution ...
1.use router transforamation .. generate 3 groups and use
sequence generator ... next value connnct to router
transformation... and logic is
mod(next,3)=1,mod(next,3)=2,mod(next,3)=0,,
connct to 3 targets load it...
| Is This Answer Correct ? | 21 Yes | 4 No |
Answer / manu
Hi Srinivas,
Even I gave the same solution. Can you please check.
| Is This Answer Correct ? | 5 Yes | 4 No |
Answer / im
Using Constraint Based Loading option in SQ T/r......
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / jayesh
Use target load plan.
Option is available in mappping designer.
| Is This Answer Correct ? | 0 Yes | 5 No |
Tell me about Propagate functions in informatica
guys which is the best institute in banglore to learn informatica??
What happens if the info. Server doesn't find the session parameter in the parameter file?
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Can we update the data in flat file using update strategy?
hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
Tell me about informatica architecture.
In informatica workflow manager, how many repositories can be created?
Explain the pipeline partition with real time example?
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
Teradata 
