Interested to Buy Any Domain ? << Click Here >> for more details...
100 records in source and i have 3 targets, my requirement
is first record insert into 1st target,2 record into 2nd
target,3 record into 3rd target and again 4th record into
1st target like dat..how to implement dis?
- 3 Answers
- 11376 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / mayur
SQ==>Sequence Generator(make it cycle of three)==> Filter
Tr==> Target
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the need of an ETL tool?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
how to load dimension table and fact table. plz tell me the steps.
How we can create indexes after completing the loan process?
Explian the Process of deployment groups in informatica
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How would you copy the content of one repository to another repository?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain your project of banking domian.
pmscmd startworkflow -sv
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How you can differentiate between connected lookup and unconnected lookup?
Describe expression transformation?
How to create Target definition for flat files?
What are the popular informatica products?
