I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
1 2742My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
TCS,
1 4046Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
HP,
8 8779I want skip first 5 rows to load in to target? what will be the logic at session level ??
IBM,
1 6169i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?
7 8707if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs
1 3371how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
2 6267If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
Puma,
7 8106Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
Cap Gemini, Puma, Wipro,
3 9241select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
Puma,
5 7324What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Puma,
1646Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Puma,
1734Post New Informatica Questions
What is meant by lookup transformation?
What is the Process to creating lookup transformation in informatica
Enlist the various types of transformations.
What is the way to execute pl/sql script using informatica mapping?
What are the various types of transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
What could be the possible resons of locks by user?
how many types of dimensions are available in informatica?
Explain about cumulative Sum or moving sum?
What is Cognos script editor?
can anyone explain me about retail domain project in informatica?
What are some examples of informatica etl programs?
Name the different lookup cache(s)?
How to elaborate powercenter integration service?
difference between repository database and repository service?