I need an oracle query for convert Char to Integer?. Can any
one help me how to do this?
Post New Answer View All Answers
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Explain what are the different versions of informatica?
What is the cumulative sum and moving sum?
How do we call shell scripts from informatica?
How will the document be delivered to me?
What are the types of caches in lookup?
what is the size of your data warehousing?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is source qualifier transformation in informatica?
What are ETL Tools?
How many types of sessions are there in informatica.please explain them?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Explain the difference between mapping parameter and mapping variable?
What is enterprise data warehousing?