While importing the relational source defintion from
database,what are the meta data of source U import?
Answer / swetha
Source name
Database location
Column names
Datatypes
Key constraints
| Is This Answer Correct ? | 6 Yes | 1 No |
What the difference is between a database, a data warehouse and a data mart?
How many joins in Informatica
How do we call shell scripts from informatica?
How to extract the informatica rejected data?
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
What are the tasks that source qualifier perform?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help
Suppose we do not group by on any ports of the aggregator what will be the output?
What are the popular informatica products?
What are the different options available for update strategy?
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.