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 2754My 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 4060Converting 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 8821I want skip first 5 rows to load in to target? what will be the logic at session level ??
IBM,
1 6192i 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 8751if 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 3390how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
2 6285If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
Puma,
7 8155Can 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 9264select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
Puma,
5 7359What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Puma,
1656Why 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,
1743Post New Informatica Questions
How to generate sequence numbers without using the sequence generator transformation?
What is the Process to creating lookup transformation in informatica
What is the commit type if you have a transaction control transformation in the mapping?
How can you increase the performance in joiner transformation?
Mention a few design and development best practices for informatica?
How can we use mapping variables in informatica? Where do we use them?
Briefly define a session task?
What is joiner change?
What is Cognos script editor?
Could you explain what is enterprise data warehouse?
what is informatica metadata?
How to generate sequence numbers using expression transformation?
How we can create indexes after completing the loan process?
How might you approve all mappings in the archive all the while?
Explain why we use partitioning the session in informatica?