Answer / babu

it displays the error message is
"yourname": invalid identifier

Answer / moorthy g

It Displays the following Messages:
>> select moorthy+1 from dual

ERROR at line 1:
ORA-00904: "MOORTHY": invalid identifier

Answer / smitha

select 'smitha+1' from dual;

Answer / uma

select 'umadevi'||'+'||1 from dual;

Answer / abhinaw prakash

Select 'Abhi'||'+1' from Dual

My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this

2 Answers  

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,

What is the Rank index port in Rank transformation?

0 Answers   Informatica,

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

0 Answers   iGate,

Examples of Fatal & Non-Fatal error?

2 Answers   Cap Gemini,

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

0 Answers   IBM,

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

What is the difference between STOP and ABORT options in Workflow Monitor?

0 Answers  

How can informatica be used for an organization?

0 Answers  

Howmany ways yoU can update a relational source defintion and what are they?

1 Answers  

How do you set a varible in incremental aggregation

0 Answers  

What are roles and groups and benefits of using them?

0 Answers