I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..
DELL,
2 8543how to read data from website into informatica? plsss send answers ASAP thanks in advance.
DELL,
1 8090i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
1 4119how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
CTS,
3 141791.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
2 18002how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
DELL,
5 11285I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
IBM,
5 9716I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
IBM,
2 6603Post New Informatica Questions
Whats there in global repository
What is option by which we can run all the sessions in a batch simultaneously?
What is persistent lookup cache?
what is mean by complex business rule ?
What is powercenter on grid?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What do you mean incremental aggregation?
what is degenerated dimension?
What is meant by a domain?
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance
How do you remove duplicate records in informatica? And how many ways are there to do it?
How can we remove the duplicates from flat file source?
explan ur project architecture?
What are the transformations that are not supported in mapplet?
Explain how to import oracle sequence into informatica?