Interested to Buy Any Domain ? << Click Here >> for more details...
I HAVE 10 records in source. I want to store i record in
target 1, second record in target 2, third record in target
3, 4 th record again in target 11, 5th again in target 2,
6th again in target3 etc.... how it is possible?
- 5 Answers
- 11477 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / koti
hi rucha could u tell me how the mod function can works and
how it will gives answer 1 or 2 or 3 only...
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
What is a filter transformation and why it is an active one?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
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
Explain sessions. Explain how batches are used to combine executions?
What is informatica metadata and where is it stored?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How to generate sequence numbers using expression transformation?
What do think which one is the better joiner or look up?
How to create a non-reusable instance of reusable transformations?
How to call shell scripts from informatica?
What is the use of source qualifier?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What the difference is between a database, a data warehouse and a data mart?
What is the cumulative sum and moving sum?
