HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?
- 7 Answers
- 30558 Views
- Patni, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bsgsr
using the informatica schedular tool or third party tools
like control m, maestro, tivoli etc. if wrong sorry
| Is This Answer Correct ? | 26 Yes | 3 No |
Answer / rajan
Informatica has own Sheduling components .Since Informatica
widely used as Data integration and Data warehousing Entity
and there are lots of depedencies on other jobs ,reason
informat application is scheduled by external sheduluing
device such as
1) Control M
2) Crontab
3) maestro
Basic Functionlity behind scheduling is PMCMD cmd thro
shell scripts they trigger informatica jobs via pmcmd
command.
| Is This Answer Correct ? | 11 Yes | 3 No |
Answer / abhas kumar jain
There are following ways:
-- Use the scheduler in WF manager.
-- Use cron scheduler in Unix.
-- Use pmcmd scheduleworkflow command.
-- Use third party enterprise schedulers like Ctrl-M,
Redwood or Tidal etc.
If any query....gimme a call on 9833547028.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / usha
1:-informataica tool its has scheduler
2:-by using UNIX also we can schedule wf (cron tab command)
3:-by using thired party tools also we can schedule wf
control_m,redwood cronical tool
third party tool is easy because we schedule wf accoring to
the customer requrement for example i want to schedule only
for leapyear.
4:- by usin shell scripts also we can schedule
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / nisith
I think no one know abt Informatica DAC-Its a scheduling
tool of informatica like control M
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / purna
scheduling is an administrative tool to perform to run the
session at a specific time and date. if wrong pls inform it
| Is This Answer Correct ? | 2 Yes | 5 No |
What do you understand by a term domain?
Explain the different kinds of facts.
What is batch and describe about types of batches?
wht is cdc?how to use it in creation of mappings?
write a query to retrieve the latest records from the table sorted by version(scd)
On which transformations you created partitions in your project?
There are 2 files, Master and User. We need to compare 2 files and prepare a output log file which lists out missing Rolename for each UserName between Master and User file. Please find the sample data- MASTER.csv ---------- Org|Tmp_UsrID|ShortMark|Rolename ---|---------|----------|------------ AUS|0_ABC_PW |ABC PW |ABC Admin PW AUS|0_ABC_PW |ABC PW |MT Deny all GBR|0_EDT_SEC|CR Edit |Editor GBR|0_EDT_SEC|CR Edit |SEC MT103 GBR|0_EDT_SEC|CR Edit |AB User USER.csv -------- Org|UserName|ShortMark|Rolename ---|--------|---------|------------ AUS|charls |ABC PW |ABC Admin PW AUS|amudha |ABC PW |MT Deny all GBR|sandya |CR Edit |Editor GBR|sandya |CR Edit |SEC MT103 GBR|sandya |CR Edit |AB User GBR|sarkar |CR Edit |Editor GBR|sarkar |CR Edit |SEC MT103 Required Output file: --------------------- Org|Tmp_UsrID|UserName|Rolename |Code ---|---------|--------|------------|-------- AUS|0_ABC_PW |charls |ABC Admin PW|MATCH AUS|0_ABC_PW |charls |MT Deny all |MISSING AUS|0_ABC_PW |amudha |ABC Admin PW|MISSING AUS|0_ABC_PW |amudha |MT Deny all |MATCH GBR|0_EDT_SEC|sandya |Editor |MATCH GBR|0_EDT_SEC|sandya |SEC MT103 |MATCH GBR|0_EDT_SEC|sandya |AB User |MATCH GBR|0_EDT_SEC|sarkar |Editor |MATCH GBR|0_EDT_SEC|sarkar |SEC MT103 |MATCH GBR|0_EDT_SEC|sarkar |AB User |MISSING Both the files are mapped through Organization, Shor_mark. So, based on each Organization, Short_Mark, for each UserName from User.csv, we need to find the Matching and Missing Rolename. I am able to bring Matching records in the output. But really I don't find any concept or logic to achieve "MISSING" records which are present in Master and not in User.csv for each UserName. Please help out guys. Let me know if you need any more information. Note:- In User.csv file, there are n number of Organization, under which n number Shortmark comes which has n number of UserName.
What are the disadvantages of Sequence Generator T/R?
i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?
what is a time dimension? give an example?
can session assigned multiple mappings or not?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Teradata 
