chandrasekar


{ City } chennai
< Country > india
* Profession *
User No # 72801
Total Questions Posted # 5
Total Answers Posted # 37

Total Answers Posted for My Questions # 12
Total Views for My Questions # 52524

Users Marked my Answers as Correct # 109
Users Marked my Answers as Wrong # 25
Questions / { chandrasekar }
Questions Answers Category Views Company eMail

I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

Wipro,

4 Informatica 6960

Why should we use star schema in datawarehouse design?

Wipro,

2 Informatica 5074

What is the difference between informatica 8.x and 9.x

Wipro,

1 Informatica 12116

How to improve the session performance in informatica?

Accenture,

3 Informatica 20054

I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com

DELL, iGate,

2 Informatica 8320



Answers / { chandrasekar }

Question { 6448 }

What is a command that used to run a batch?


Answer

Using PMCMD command is used to communicate an Intergration
services.
Using the PMCMD>connect -sv services -d domain -u username
-p password.

the above one is syntax for used connet to an Intergration
services.

PMCMD>startworkflow -f foldername workflow_name.

It is used to execute the worflows.

If it is wrong means please mail to me chandranmca2007@gmail.com

Is This Answer Correct ?    4 Yes 0 No

Question { 5762 }

What is parameter file?


Answer

Mapping Parameter is a constant value that can be defines in
before mapping run.

Mapping parameter file is created using Notepad or wordpad
with the extension of .txt or .prm.

If i wrong means mail to me chandranmca2007@gmail.com

Is This Answer Correct ?    0 Yes 0 No


Question { 10569 }

what are the transformations that are used in data
cleansing ? and how data cleansing takes place ?


Answer

Hi Friends,

My point of view FILTER AND EXPRESSION TRANSFORMATIONS are
used to data cleansing.

Is This Answer Correct ?    0 Yes 0 No

Question { 5507 }

Plz can anybody send Informatica and Cognos FAQ
Plz To thid ID ppradeep_dwh@ayhoo.co.in


Answer

Hi Arjun,

Please send the latest congnos FAQ's to my mail id.

Id is chandranmca2007@gmail.com

Thanks in advance..

Is This Answer Correct ?    0 Yes 0 No

Question { 9139 }

How to retrieve last two days updated records?


Answer

We can use an expression transformation
add_to_date(sysdate-2) it is retrives last two date using
this we can update the records.

If it wrong means please mail me chandranmca2007@gmail.com

Is This Answer Correct ?    1 Yes 0 No

Question { HCL, 10969 }

2.What is staging area ?


Answer

Staging area is a nothing but storage area or parking area
to store the multiple source date. It will
transform,combine, cleanse data,do the simple business logic
and prepare the source data for datawarehouse.

Is This Answer Correct ?    2 Yes 0 No

Question { 11092 }

how to convert the .doc docs into .txt format using
informatica


Answer

Hi Amarnath,

Your answer is to import the .doc,pdf file format files into
informatica but how we can convert .doc into .txt.Bacause
the above question is converting?

Can u please explain?????

Please mail me chandranmca2007@gmail.com

Is This Answer Correct ?    0 Yes 0 No

Question { Patni, 6679 }

What is junk dimention?


Answer

A Dimension which not participated in the key performance
indicator.

Eg : phone number, address.

If it is wrong means please mail me chandranmca2007@gmail.com

Is This Answer Correct ?    0 Yes 0 No

Question { CTS, 7257 }

Hi,

Can you please send me the Informatica 8 certification exam
dumps to my email id rwork.san@gmail.com

Thanks,
Revathi.


Answer

Hi Revathi,

Please send the informatica certification dump for my mail
id also.

chandranmca2007@gmail.com

Is This Answer Correct ?    0 Yes 0 No

Question { Accenture, 12700 }

How can u insert o ne row in the target if that row does not
exists in the target and update if it exists


Answer

Hi Sudhar,

Please check your answer it is not working....

We can use the SCD type 1 only get the new row as insert
into target and updated record as update into target.

If it wrong means please mail me.. chandranmca2007@gmail.co

Is This Answer Correct ?    0 Yes 0 No

Question { Keane India Ltd, 18711 }

What is the query to find nth highest salary?
What is the use of cursors?


Answer

Hi Suraj,

Your SQL query is not working? so please try in oracle and
once again load to site.

Thanks for ur help.

Is This Answer Correct ?    1 Yes 0 No

Question { Ness Technologies, 5555 }

what is system requirement(SR) & business requirement(BR)?


Answer

SRS(System Requirement Specification): What are system
specifications we need to use in the project. A Senior
Technical coordinator will prepare the document.

It covers, What is the os we need to use , and what are the
RDBMS, what are the OLAP tools, RAM capacity.

All the requirements are mentioned in this document.

BRS(Business Requirement Specification): The business
analyst will sit together with business managers and prepare
the business requirements and documented in the word format.

Business analysts and business user community people will
prepare the Business Requirement specification.

This document will forwarded to next phase for designing.

Is This Answer Correct ?    2 Yes 0 No

Question { L&T, 5139 }

i have 2 session s1 execute s2 load first session fail what
is the reason?


Answer

I think s2 dependent to s1 then only we load the s2 session
first at a time fails. First load the s1 and s2 it can be
executed correctly.

If it wrong means please mail me chandranmca2007@gmail.com

Is This Answer Correct ?    0 Yes 0 No

Question { TCS, 6782 }

how to use incremental load?


Answer

Whenever an OLTP records update or insert in the source
,then the records are loaded in to target as a new record.

Using SCD type 2 we can acheive the incremental load.

If it wrong means chandranmca2007@gmail.com

Is This Answer Correct ?    3 Yes 0 No

Question { iGate, 8595 }

My source table having some records ,i want load 1st record
and last record into one target?


Answer

I took the EMP table and we can use the below query in the
SQL override,

select * from emp where rownum=1 union select *
from emp where rowid=(select max(rowid) from
emp);

it will work.

Is This Answer Correct ?    7 Yes 0 No

 [1]   2   3    Next