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
- 11254 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / teja_dwh
By using sequence generator properties we can do this.
setting the properties like below
start value:1
end value:3
cycle:yes
reset:yes
increment by:1
we can achieve the result by this way.
cheers
teja
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
Enlist the differences between database and data warehouse.
What are the components of Informatica? And what is the purpose of each?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
my source is junk data how will u remove that junk data by using unix please any one replay me
Describe an informatica powercenter?
Describe the impact of several join conditions and join order in a joiner transformation?
Is it possible to use a client with different version than that of its Informatica server?
wat are deployement groups in informatica, how it will be used for developers
Global and Local shortcuts. Advantages.
what is the -ve test case in your project.
In informatics server which files are created during the session rums?
