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
- 14538 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / krishna
for importing data from an excel file you have to open the
excel file and define it first. then from informatica you
can invoke import from excel option. but the question is
something like how to divide a column data into two viz.,
city and state. probably you have to use a function like
to_char to convert the data or trim to cut the state part
and so on.........
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is workflow? What are the components of workflow manager?
What is domain in terms of informatica?
What do you mean by channel change?
Which version configuration tool used in ur project?
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 an aggregator cache file?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How can you validate all mappings in the repository simultaneously?
What are the differences between a connected lookup and unconnected lookup?
What is the use of target designer?
What are the different versions of informatica?
How do you load unique records into one target table and duplicate records into a different target table?
Separate from a database, an information bazaar, and an information stockroom?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
