I've an excel sheet, in which one column contains data about
the location like "City, State" and few columns contains
only "State". Now I wanna load into my target City and State
into two different columns. Pls help me out...
Answer Posted / informatica-user
use excel driver
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to configure mapping in informatica?
Why union transformation is an active transformation?
Scheduling properties,whats the default (sequential)
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
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 could be the possible resons of locks by user?
What is meant by a domain?
What is flashback table ? Advance thanks
What does command task mean?
What are the tasks that can be performed using sq?
What are connected or unconnected transformations?
update strategy transformation in informatica
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How to use procedural logic inside infromatica?
Does an informatica transformation support only aggregate expressions?