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?
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
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
generate date / time dimension in informatica
What is informatica powercenter repository?
How do you promote a non-reusable transformation to reusable transformation?
What are the new features of informatica 9.x in developer level?
What is a joiner transformation?
How do you migrate data from one environment to another?
write a query to retrieve the latest records from the table sorted by version(scd)
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Target increases every day even though no new record was inserted
How to use pmcmd utility command?
Implementation methodology
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com