Answer Posted / saradhi
by using concatination operator u can get it.
firstname||lastname
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
Explain the etl program with few examples.
What are the types of caches in lookup? Explain them.
What is Data Caches size?
What the difference is between a database, a data warehouse and a data mart?
Explain the aggregator transformation?
Explain pmcmd command usage in informatica
What are the features of complex mapping?
What is a filter transformation and why it is an active one?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Can informatica load heterogeneous targets from heterogeneous sources?
Enlist the advantages of informatica.
What are the designer tools for creating transformations?
How to load the data from a flat file into the target where the source flat file name changes daily?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
scenario where i can use only concurrent execution of workflow.