How do you handle decimal places while importing a flatfile
into informatica?
Answer / maruthi
1.)use to_integer('column name','newcolumn)
it works
Is This Answer Correct ? | 6 Yes | 4 No |
What is workflow? What are the components of the workflow manager?
If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?
hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you
What is Cognos script editor?
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in
Which version configuration tool used in ur project?
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
What is incremental aggregation?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
What is a candidate key?
Performance tuning( what you did in performance tuning)