| Back to Questions Page |
| |
| Question |
Hello all,
Source Table(Flat File):- Target Table(Flat File):-
Date Date
01/08/2008(DD/MM/YYYY) 01/08/2008
02/08/2008
03/08/2008
04/08/2008
05/05/2008
My requiremnt is this. I need to do it by informatica,Plz
tell me how can i do it?
Thanks
|
Rank |
Answer Posted By |
|
Question Submitted By :: Amrita |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | The simplest thing U can do is
while importing the source flatfile using "Flat File Import
Wizard"
In Step1 choose-> FixedWidth
in the step2 -> click and create a column or tab on the
field then U can import them as 2 fields
1. 01/08/2008
2.(DD/MM/YYYY)
U can ignore the second column and use the first one.
second method is by taking only the date value in
Expression Transformation.
Hope this of any help
Kal  |
| Kal
|
| |
| |
| Answer | In expression transfromation
to_date(datecolumnname,dd/mm/yyyy) and pass this link upto
target |
| Bhagya
|
| |
| |
| Question |
Where can i get informatica certification Exam dumps and
details? please forward it to emailid: krisboppana@yahoo.com |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
| This Interview Question Asked @ NexGen |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | pls cc to my id also |
| Dainty
|
| |
| |
|
|
| |
| Answer | pls let me know the same, if any dumps, identified for
informatica 8.1.1 |
| Jayakumar
|
| |
| |
| Answer | please cc to my id also.My id is nagasundarsai@gmail.com |
| Nagasundar
|
| |
| |
| Answer | i hv it |
| Gopi
|
| |
| |
| Answer | Kindly forward the informatica dumps to my mail id
inbaraj06@gmail.com |
| Inbarajayui
|
| |
| |
| Answer | fwd me too @ ravee21@yahoo.com |
| Prasad
|
| |
| |
| Answer | cc to me also... daintymoses@gmail.com |
| Dainty
|
| |
| |
| Answer | Please post it to abh_vish@yahoo.com too.
Thanks a lot |
| Abhay
|
| |
| |
| Answer | Please post it to my mailid also vijay.hari@indiatimes.com |
| Vijay
|
| |
| |
| Answer | Please forward me too at naval.garg@gmail.com. Thanks os
advance :-) |
| Naval
|
| |
| |
| Answer | HI
I am also looking to get certified in informatica. Can
someone please forward me the dump of all three
certificaions as well. my email is ahsan_0@hotmail.com
Thanks in advance
SN. |
| Sn9999
|
| |
| |
| Answer | I am also looking to get certified in informatica. Can
someone please forward me the dump of all three
certificaions as well. Let me know wer can i appear for
this exam and my mail id is:sri.gupta5@gmail.com |
| Srinivas
|
| |
| |
| Answer | Can you also email me at : vikramv786@yahoo.com? |
| Vikram
|
| |
| |
| Answer | kindly send informatica dumps to jazz440@yahoo.co.in..thanks
in advance |
| Deb
|
| |
| |
| Answer | pls keep me in loop , i need papers as well
anilsingh_9393@yahoo.com |
| Anil
|
| |
| |
| Answer | Please forward the dumps to ashu_sggs@yahoo.com |
| Ashwin
|
| |
| |
| Answer | Pls send me the dump to my id sarathy84@gmail.com
thanks |
| Sarathy
|
| |
| |
| Answer | Pls send me the dump to my id bhushan.kankhar@gmail.com
thanks |
| Bhushan
|
| |
| |
| Answer | I too need it. Please send it to: itsmesaurav79@gmail.com |
| Saurav
|
| |
| |
| Answer | Hi,
can you please mail me the inforamtica 8 dumps to my id
Surajthyagarajan@gmail.com
Thanks in advance |
| Suraj
|
| |
| |
| Answer | could you please send it to me too...i am in need of them
badly...Thanks in advance
My id:torenuka@indistimes.com |
| Renuka
|
| |
| |
| Answer | Could you please send the informatica Dumps to me tooo... |
| Ponnambalam
|
| |
| |
| Answer | Could You plz send me the informatica latest dumps if
anyone have it....
My Mail ID: ponnambalam.thiagarajan@gmail.com
Thanks in Advance |
| Ponnambalam
|
| |
| |
| Answer | Please forward to my mail id also.
chvamshy@gmail.com |
| Vamshi
|
| |
| |
| Answer | Can you please mail me a copy of Informatica Certification
Exam dumps to krknagarajan@gmail.com
-Thanks in Advance. |
| Nagarajan
|
| |
| |
| Answer | Can someone please forward the email with the dump to me
too at singh.bhavdeep@gmail.com |
| Bhavdeep Singh
|
| |
| |
| Answer | pls cc to my id too jijokt@gmail.com |
| Jijo
|
| |
| |
| Answer | could you please send it to me too...i am in need of them
badly...Thanks in advance
My id:vidudhalai@gmail.com |
| Bhuvana
|
| |
| |
| Answer | Hi,
can you please forward me the Informatica dump.
I'm preparing for the certification.
thanks in advance,
Regards,
Ranga
macsrangs@gmail.com |
| Ranga
|
| |
| |
| Answer | I am also looking for Informatica certification.
Can someone please send the dumps to my mail id :
sree_bit03@yahoo.com
Please do the needful.
Thanks,
Sree |
| Sree
|
| |
| |
| Answer | Hi
I also need the dup. Can someone forward it to me
vidhya_rangan_85@yahoo.com or vidhya.rangan@gmail.com
Thanks,
Vidhya |
| Vidhya
|
| |
| |
| Answer | Please post the dumps to my mail @
ramakrishna.innmuri@gmail.com Thanks... |
| Ramakrishna
|
| |
| |
| Answer | can any one send the copy of this to my id
prasana_2411@yahoo.com |
| Prasana
|
| |
| |
| Answer | Pls send me the dump to my id saxenamudit@gmail.com
thanks |
| Mudit Saxena
|
| |
| |
| Answer | NO where.. |
| Abc
|
| |
| |
| Answer | Pls send me the dump to my id jayasreenivas.babu@gmail.com |
| Jaya Sreenivas
|
| |
| |
| Question |
In the SEQ generator which property has to be set to
generate seq No. when the input data is more than the max
limit. |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
| This Interview Question Asked @ Accenture , Accenture |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Cycle |
| Bhaskar
|
| |
| |
| Answer | u can generate manually also. |
| Raj
|
| |
| |
| Question |
Which type or t/s is used to convert rows into column &
column into rows |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
| This Interview Question Asked @ Infosys |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | You can achieve through Normalizer t/f |
| Krishna
|
| |
| |
| Answer | by using normaliser ransformation only you can convert the
rows to columns and vice versa |
| Vijay
|
| |
| |
| Answer | By using normalizer transformation we can use the conditions
only applied for row by columns..
by using the normalizer output we can use the function (first)
and then applied for conditions ..and then output will be
seen in column by rows.... |
| Murugan
|
| |
| |
| Answer | Row To columns
--------------
Use Normalizer Transformation
Column To Rows
--------------
SOURCE
------
ENO COL_HDR COL_VAL
------------------------
1 ENAME PRAKASH
1 ESAL 35000
2 ENAME SREE
2 ESAL 25000
OUTPUT
------
ENO ENAME ESAL
1 PRAKASH 35000
2 SREE 25000
MAPPING LOGIC
--------------
SRC -----> AGG -----> TGT
Use First Function in Aggegrator to convert the Column to
rows
In Aggegrator, Create two output columns and write the
following expression
Port Name Expression
--------- ----------
O_ENAME FIRST(COL_VAL,COL_HDR='ENAME')
O_ESAL FIRST(COL_VAL,COL_HDR='ESAL')
Please get back to me in case of queries.
Thx & Regards,
Prakash Chandran |
| Prakash Chandran
|
| |
| |
| Question |
How can write SQL Overwrite to get Daynamic rows from the
source in SQ transformation!(Any Example) |
Rank |
Answer Posted By |
|
Question Submitted By :: Anjaniya |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | by using the sql override option in the edit properties in
s.q transformation, |
| Sarvesh
|
| |
| |
| Question |
if u can't find what you are looking for in lookup table,
how do you handle? |
Rank |
Answer Posted By |
|
Question Submitted By :: Jakki |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | This Depend on the situation,
To Check the value is there or not there two ways
1. Use notfound function (if possible)
2. Check the Key value from lkp as NULL
Than based on the requirement generate error/Put default
value |
| Raj.arjunan
|
| |
| |
| Question |
how do u implement unconn.stored proc. in a mapping? |
Rank |
Answer Posted By |
|
Question Submitted By :: Jakki |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | unconn.stored procedure is implemented by the exprression
transformation as :sp.proc2(sal,proc_result),here proc2 is
the procedure name |
| Sarvesh
|
| |
| |
| Question |
how do u set the size of block buffer? |
Rank |
Answer Posted By |
|
Question Submitted By :: Jakki |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | go to edit properties in any of the following trans like
rank,lookup,joiner,aggregator,there u can change the size
of buffer,but by dewfault it is 64kb. |
| Sarvesh
|
| |
| |
| Question |
what are the facilities provided by OLAP to analytical users? |
Rank |
Answer Posted By |
|
Question Submitted By :: Jakki |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | 1.)MULTI-DIMENSIONAL ANALYSIS
2>)AD-HOC QURIES
3.)REDUCED REDUNDANCY
4.)AGGREGATED DATA
5.)SECURITY
|
| Maruthi
|
| |
| |
|
| |
|
Back to Questions Page |
Site Map
