Answer Posted / chandu
count(1) means it will count based on 1st column in the
select statement
| Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
Scheduling properties,whats the default (sequential)
How to create the source and target database connections in server manager?
What is the session task and command task?
What are the different clients of powercenter?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is expression transformation?
What is complex mapping?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
server hot-ws270 is connect to Repository B. What does it mean?
What is olap (on-line analytical processing?
Mention a few design and development best practices for informatica?
What is an Integration service in Informatica?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is the use of transformation?