Answer Posted / ramesh.b
Use Expression transformation write condition Concat(firstname,lastname)
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How do you manage the Parameter files while migrating your data from one environment to another environment?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is blocking transformation?
How do you migrate data from one environment to another?
What is sq transformation?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What are the different types of repositories created using informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What all are steps in up gradation of Informatica server?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Suppose we do not group by on any ports of the aggregator what will be the output?
What is a snowflake schema?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Define mapping and session?
