Interested to Buy Any Domain ? << Click Here >> for more details...
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...
- 6 Answers
- 14746 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / nagraju bhatraju
We can't import excel sheet directly in to informatica,
instead , we have to save that file in .csv(Comma Separated
Value Formatt) and then we can use or analyze in
informatica environment.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what is the hint? how to use it to reduce the query processing in program?
In informatics server which files are created during the session rums?
Explain the different lookup methods used in informatica?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is meant by target load plan?
When do you use sql override in a lookup transformation?
What is sq transformation?
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 are the different types of olap? Give an example?
What is meant by LDAP users?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How do you take back up of repository?
can u any challenge your project?
How do you load first and last records into target table?
